BEGIN TRANSACTION
GO
ALTER TABLE dbo.Items ADD
	Cost numeric(7, 2) NOT NULL CONSTRAINT DF_Items_Cost DEFAULT 0
GO
COMMIT

-----------------------------------

BEGIN TRANSACTION
GO
ALTER TABLE dbo.ItemsDetail ADD
	Cost2 numeric(7, 2) NOT NULL CONSTRAINT DF_ItemsDetail_Cost2 DEFAULT 0
GO
COMMIT

-----------------------------------

ALTER VIEW [dbo].[vw_Items]
AS
SELECT     dbo.Items.GroupID, dbo.Groups.GroupCode, dbo.Groups.GroupName, dbo.Groups.GroupNameUrdu, dbo.Groups.Type, dbo.Items.ItemID, dbo.Items.ItemCode, dbo.Items.ItemName, dbo.Items.ItemNameUrdu, dbo.Items.Rate, dbo.Items.Discontinue, dbo.Items.UnitName, dbo.Groups.myPrinterName, dbo.Items.ItemRemarks, dbo.Items.Cost
FROM         dbo.Groups RIGHT OUTER JOIN
                      dbo.Items ON dbo.Groups.GroupID = dbo.Items.GroupID

-----------------------------------

ALTER VIEW [dbo].[VW_Vouchers]
AS
SELECT     dbo.VoucherDetails.VoucherID, dbo.Voucher.VoucherDate, dbo.Voucher.VoucherNo, dbo.Voucher.SessionID, dbo.Voucher.Remarks AS MasterRemarks, dbo.Voucher.ReadOnly, 
                      dbo.VoucherDetails.VoucherDetailID, dbo.VoucherDetails.AccountNo, dbo.Accounts.AccountTitle, dbo.SessionInfo.SessionTitle, dbo.VoucherDetails.Remarks, 
                      CASE WHEN (dbo.VoucherDetails.DrOrCr = N'Dr') THEN dbo.VoucherDetails.Amount ELSE - 1 * dbo.VoucherDetails.Amount END AS Amount, CASE WHEN (dbo.VoucherDetails.DrOrCr = N'Dr') 
                      THEN dbo.VoucherDetails.Amount ELSE 0 END AS Debit, CASE WHEN (dbo.VoucherDetails.DrOrCr = N'Cr') THEN dbo.VoucherDetails.Amount ELSE 0 END AS Credit, dbo.VoucherDetails.DrOrCr, 
                      dbo.Accounts.ParentAccount, dbo.Voucher.BankAccountID, Accounts_1.AccountTitle AS BankAccountTitle, Accounts_1.Remarks AS BankAddress, Accounts_1.CellNo AS BankCellNo, 
                      Accounts_1.Phone AS BankPhone, ISNULL(dbo.Voucher.CustomerName, '') AS CustomerName, dbo.Voucher.Amount AS VoucherAmount, dbo.Voucher.TotalAmount, dbo.Voucher.NetAmount, 
                      dbo.Voucher.ServiceCharges, dbo.Voucher.Discount, dbo.Voucher.LoginID, dbo.Employees.EmployeeName, dbo.Voucher.HostName, dbo.Voucher.EntryDateTime, dbo.vw_Items.GroupID, 
                      dbo.vw_Items.GroupCode, dbo.vw_Items.GroupName, dbo.vw_Items.GroupNameUrdu, dbo.vw_Items.Type AS ProductType, dbo.VoucherDetails.ItemID, dbo.vw_Items.ItemCode, 
                      dbo.vw_Items.ItemName, dbo.vw_Items.ItemNameUrdu, dbo.vw_Items.UnitName AS ItemUnitName, dbo.VoucherDetails.Qty, dbo.VoucherDetails.Rate, dbo.VoucherDetails.Amount AS ActualAmount, 
                      dbo.Voucher.UnitID, dbo.Unit.UnitCode, dbo.Unit.UnitName, dbo.Unit.UnitNameUrdu, dbo.Unit.AreaID, dbo.Area.AreaCode, dbo.Area.AreaName, dbo.Area.AreaNameUrdu, dbo.Voucher.KOTNo2, 
                      dbo.Voucher.ModifyID, dbo.Voucher.ModifyHost, dbo.Voucher.ModifyDateTime, dbo.Voucher.OrderType, dbo.Voucher.CellNo, dbo.Voucher.Address, dbo.Voucher.BillDate, dbo.Voucher.ShiftCID, 
                      dbo.Voucher.ShiftID, dbo.Voucher.GST, dbo.Voucher.Cash, dbo.Voucher.RefVNo, dbo.Shift.ShiftCode, dbo.Shift.ShiftName, dbo.SessionInfo.CurrentSession, dbo.vw_Items.ItemRemarks, dbo.vw_Items.myPrinterName, dbo.vw_Items.Cost
FROM         dbo.Voucher LEFT OUTER JOIN
                      dbo.Shift ON dbo.Voucher.ShiftID = dbo.Shift.ShiftID LEFT OUTER JOIN
                      dbo.Unit LEFT OUTER JOIN
                      dbo.Area ON dbo.Unit.AreaID = dbo.Area.AreaID ON dbo.Voucher.UnitID = dbo.Unit.UnitID LEFT OUTER JOIN
                      dbo.Accounts AS Accounts_1 ON dbo.Voucher.BankAccountID = Accounts_1.AccountNo LEFT OUTER JOIN
                      dbo.Employees ON dbo.Voucher.LoginID = dbo.Employees.EmployeeID RIGHT OUTER JOIN
                      dbo.Accounts RIGHT OUTER JOIN
                      dbo.VoucherDetails LEFT OUTER JOIN
                      dbo.vw_Items ON dbo.VoucherDetails.ItemID = dbo.vw_Items.ItemID ON dbo.Accounts.AccountNo = dbo.VoucherDetails.AccountNo ON 
                      dbo.Voucher.VoucherID = dbo.VoucherDetails.VoucherID LEFT OUTER JOIN
                      dbo.SessionInfo ON dbo.Voucher.SessionID = dbo.SessionInfo.SessionID

-----------------------------------

ALTER VIEW [dbo].[VW_KOTs]
AS
SELECT     dbo.KOT.KOTID, dbo.KOT.KOTDate, dbo.KOT.KOTNo, dbo.KOT.IsBilled, dbo.KOT.LoginID, dbo.KOT.HostName, dbo.KOT.EntryDateTime, dbo.KOT.UnitID, dbo.Unit.UnitCode, dbo.Unit.UnitName, 
                      dbo.Unit.UnitNameUrdu, dbo.Unit.AreaID, dbo.Area.AreaCode, dbo.Area.AreaName, dbo.Area.AreaNameUrdu, dbo.KOTDetail.KOTDetailID, dbo.KOTDetail.AccountNo, dbo.Accounts.AccountTitle, 
                      dbo.KOTDetail.ItemID, dbo.vw_Items.ItemCode, dbo.vw_Items.ItemName, dbo.vw_Items.ItemNameUrdu, dbo.vw_Items.GroupID, dbo.vw_Items.GroupCode, dbo.vw_Items.GroupName, 
                      dbo.vw_Items.GroupNameUrdu, dbo.vw_Items.Type, dbo.vw_Items.UnitName AS ItemUnitName, dbo.KOTDetail.Qty, dbo.KOTDetail.Rate, dbo.KOTDetail.Amount, dbo.KOT.KOTNo2, 
                      dbo.KOT.ModifyID, dbo.KOT.ModifyHost, dbo.KOT.ModifyDateTime, dbo.KOTDetail.IsPrint, dbo.KOTDetail.IsDel, dbo.KOT.OrderType, dbo.KOT.CellNo, dbo.KOT.CustomerName, dbo.KOT.Address, 
                      dbo.KOT.ShiftCID, dbo.KOT.ShiftID, dbo.KOT.Amount AS vAmount, dbo.KOT.GST, dbo.KOT.ServiceCharges, dbo.KOT.TotalAmount, dbo.KOT.Discount, dbo.KOT.NetAmount, dbo.Shift.ShiftCode, 
                      dbo.Shift.ShiftName, dbo.vw_Items.myPrinterName, dbo.KOT.Status, dbo.vw_Items.ItemRemarks, dbo.vw_Items.Cost
FROM         dbo.vw_Items RIGHT OUTER JOIN
                      dbo.KOT INNER JOIN
                      dbo.KOTDetail ON dbo.KOT.KOTID = dbo.KOTDetail.KOTID LEFT OUTER JOIN
                      dbo.Shift ON dbo.KOT.ShiftID = dbo.Shift.ShiftID ON dbo.vw_Items.ItemID = dbo.KOTDetail.ItemID LEFT OUTER JOIN
                      dbo.Area INNER JOIN
                      dbo.Unit ON dbo.Area.AreaID = dbo.Unit.AreaID ON dbo.KOT.UnitID = dbo.Unit.UnitID LEFT OUTER JOIN
                      dbo.Accounts ON dbo.KOTDetail.AccountNo = dbo.Accounts.AccountNo

-----------------------------------